
/****** Object:  Table [dbo].[Sample_App]    Script Date: 11/21/2011 16:01:53 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO
Create Database Sample_DB
Go

USE Sample_DB
GO



CREATE TABLE [dbo].[Sample_App](
	[Age] [nchar](10) NOT NULL,
	[First_Name] [varchar](50) NULL,
	[Last_Name] [varchar](50) NULL,
	[Marks_Obtained] [nchar](10) NULL,
	[Roll_Number] [int] IDENTITY(1,1) NOT NULL,
	[AdultOrNot] [nchar](10) NULL,
PRIMARY KEY CLUSTERED 
(
	[Roll_Number] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[Sample_App] ON
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'26        ', N'Raj', N'Kamal', N'78        ',1,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'26        ', N'Vipul', N'Mehta', N'80        ', 2,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'27        ', N'Ranjit', N'Gupta', N'82        ', 3,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'44        ', N'Mark', N'DSouza', N'89        ', 4,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'45        ', N'Senthil', N'Kumar', N'78        ', 5,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'80        ', N'Wassim', N'Melhem', N'78        ', 6,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'98        ', N'Nashat', N'Sanuri', N'809       ', 7,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'32        ', N'Umit', N'Tiric', N'89        ', 8,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'23        ', N'Marlon', N'Grech', N'23        ', 9,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'32        ', N'James', N'Broome', N'89        ', 10,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'34        ', N'Daniel', N'Vella', N'37        ', 11,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'788       ', N'Praveena', N'Edpuganti', N'87        ', 12,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'89        ', N'Ashraf', N'Khader', N'8         ', 13,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'980       ', N'Gunjan', N'Jain', N'98        ', 14,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'9         ', N'Naveen', N'Kumar', N'9         ', 15,N'False')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'8         ', N'Ravi', N'Kumar', N'9         ', 16,N'False')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'87        ', N'Das', N'Kumar', N'78        ', 17,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'9         ', N'Jaykant', N'Sharma', N'9         ', 18,N'False')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'23        ', N'Shilpa', N'Kumari', N'23        ', 19,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'76        ', N'Meena', N'Goyal', N'76        ', 20,N'True')
INSERT [dbo].[Sample_App] ([Age], [First_Name], [Last_Name], [Marks_Obtained], [Roll_Number],[AdultOrNot]) VALUES (N'32        ', N'Ajay', N'Verma', N'89        ', 21,N'True')
SET IDENTITY_INSERT [dbo].[Sample_App] OFF


